Best Of
ガントチャートについて
ガントビューの活用方法について質問です。
一つのタスクバーに対して、タスク全体の色ではなく、特定の期間だけ色を変更することはできますか？
例えば、1年間のタスクバーがあったとして、11月、12月分だけ赤色にしたいです。
いい方法があれば教えていただけると助かります。
Teraji_55
3 Levels of Hierarchy?
I am building a workspace with 3 separate levels: Master Overview Dashboard, 3+ team dashboards, & 5+ representative dashboards per team. I want the individual representative to be able to input data via a form and have control to edit a few columns.
Each rep will "own" the data they input. Only want that data to flow to team & master. There will be a few checkboxes for each row of data as well as a couple dropdown boxes.
I want each team dashboard to consolidate the individual rep data and have a "team overview" that will look slightly different from the reps dashboard.
The master dashboard will only show the teams combined data as a whole.
Biggest concern is the addition of new rep dashboards over time. Want the easiest process of adding new rep, associating them with a specific team statically, and having that data flow up to the master.
Start at the top and flow down or down to up?
rs.br.cap
Re: Auto Refresh of Published Dashboards
I'd also love this feature. We currently have our Smartsheet account representatives on site and they had a link with a dashboard, that they had to manually refresh to see the new results.
What if, published dashboards just auto-refreshed at a certain rate.
Courtney
Re: Having issues with Year formulas
Try this:
=(YEAR([Date Completed]@row) - YEAR(Age@row) - IF(MONTH([Date Completed]@row) < MONTH(Age@row), 1, 0)) + " Y " + (MONTH([Date Completed]@row) - MONTH([Date Completed]@row) + IF(MONTH([Date Completed]@row) < MONTH(Age@row), 12, 0)) + " M"
Paul Newcome
Re: Allow New Users Under the New User Subscription Model to be set to Viewer
I agree with the above, this all seems like a big money grab by Smartsheets. We are now going through our first "true up". There should be admin controls that allow only certain people to share at anything above the viewer level, It should be possible to limit the number of licenses to the number we have purchase. This has come to the attention of our corporate software dept, which has threatened to force the PMO to use another system if we are unable to keep the costs at what was negotiated with Smartsheets.
TCJ
Re: User subscription model (USM) - provisional status visible and obvious for end user
110% correct! I will go one step further and say the System Admin also needs to be notified. In a larger company (like mine) it is all but impossible to manage the provisional members without knowing WHEN the membership was created, WHO created it, and from WHICH asset.
Kelly Ospina
Re: Form Pages
I think there is a lot of room for improvement for Forms. This would be a nice feature to have. We use forms for applications and having multiple pages (especially if previous entries are SAVED), would be a great added feature. We are currently forced to utilize Form Assembly, for this reason. Smartsheet forms look nice, are more customizable, and automatically populate data in spreadsheets... it would be nice to be able to use Smartsheet for our more lengthy applications.
vdemattei
Re: Tabbing through "pages" in form
We use forms for patient's. and our employee has to fill out some items at the top (because we have to have it all on one page), however if the patient scrolls up they are able to change information and submit it before our employee can see it. A page break would BE BUSINESS CHANGING!!!
Kari G
Toggle Column Filters
It would be a time saving feature in place of the existing conditions feature function to have the option of a toggle on/off column filter feature that provide at the column a quick filtering options based on the column types (date - date filters, text - text filters) and include a text field to type in a value; and the ability to filter by column formatting colors.
Yes, but I am referring to something similar to what is available in E*cel. It's a simple yet effective feature. I added screenshots for reference.
Thank you.
Vanessa Scott
Re: Licenses and True-up confusion
Hello.
So, point 3 - This is contradictory. You say I can adjust the role if I have someone who still needs to contribute to sheets without having full Member access, but then you say it's either Member or Viewer.
I have someone who contributes to one sheet only. Are you saying I now have to give them full Member access? That isn't financially viable and completely misses the point of having sheets that are collaborative!
Katie
KatieDi